# coding=utf-8


import pyodbc
import smtplib
from email.mime.text import MIMEText
from email.mime.multipart import MIMEMultipart
from email.header import Header 
import importlib
import sys
#importlib.reload(sys)
#reload(sys)
#sys.setdefaultencoding('utf8')
# release schedule https://confluence/display/PGM/Release+Schedule

class DBConnect:
    def __init__(self,serverName,databaseName):
        self.serverName=serverName
        self.databaseName=databaseName
    def openConn(self):
        conn1=pyodbc.connect('Driver={SQL Server};'
                      'Server='+self.serverName+';'
                      'Database='+self.databaseName+';'
                      'Trusted_Connection=yes;')
        return conn1        